Model Table FAILING COMPONENT
This model dimension represents Failing Component and is based on the IFS Cloud
dimension DIM_FAILING COMPONENT. All models that refers to this dimension will have
the attributes and hierarchies as described below.
Attributes
| Attribute |
Description (where applicable) |
| Error Cause | Represents the error cause |
| Error Type Code | Represents the code of the Error type |
| Failing Component Cause Desc | Represents the description of the Failing Component |
| Failing Component Error | Built as ITEM CLASS ID +' - ' + FUNCTION ID + ' - '
+ ERR TYPE + '- '+ CODE+ ' - ' + CAUSE DESCRIPTION |
| Failing Component ID | Represents the code of the Failing component |
| Function ID | represents the Function ID Code |
| Item Class ID | Represents the ID of the Item Class |
| Hierarchy |
Level |
| FailCompHy | |
| Item Class ID |
| Function ID |
| Error Type Code |
| Failing Component Cause Desc |
| Failing Component ID |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
| Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
| FAILING COMPONENT | DIM_FAILING_COMPONENT_TM | DIM_FAILING_COMPONENT_BI | DIM_FAILING_COMPONENT | On Line |